A New Approach for Semantic Integrity Constraints Representation in Enhanced Entity-Relationship and Relational Database Schemas
نویسنده
چکیده
In this paper Semantic-Enhanced Entity Relationship (SEER) and Semantic – Relational Database (SRD) diagrams are proposed. SEER and SRD are extensions of Enhanced Entity Relationship (EER) and Relational Database (RD) diagrams respectively that are based on dealing with Semantic Integrity Constraints. EER and RD do not take semantic constraints in matter. A lots of information are lost because of the shortage of documentations. The proposed SEER and SRD models embed the semantic constraints using a new notations and pseudo code to give a full diagram for a database system. The proposed models handle the documentation shortage problem.
منابع مشابه
Enforcing Cardinality Constraints in the ER Model with Integrity Methods
Copyright © 2002, Idea Group Publishing. Entity-Relationship (ER) schemas include cardinality constraints that restrict the dependencies among entities within a relationship type. The cardinality constraints have direct impact on application transactions, since insertions or deletions of entities or relationships might affect related entities. Application transactions can be strengthened to pre...
متن کاملEnhancing the ER Model with Inegrity Methods
Entity Relationship (ER) schemas include cardinality constraints, that restrict the dependencies among entities within a relationship type. The cardinality constraints have direct impact on application transactions, since insertions or deletions of entities or relationships might affect related entities. Application transactions can be strengthened to preserve the consistency of a database with...
متن کاملConflict Resolution and Reconciliation in Multidatabase S..
A multidatabase system is built upon a number of existing database systems. It requires an interface to allow users to access global heterogeneous information within a reconciled platform as well as to maintain the data consistence and integrity among existing database systems. As a result, a higher level semantic global database schema is needed. The global schema is a single schema derived fr...
متن کاملFunctional Dependencies for Object Databases
There is an increasing use of object oriented methods (e.g. [Ru91], [UML97]) for the design of database applications and databases themselves. Like the Entity–Relationship model and its variants, structural models of these methods provide rich modelling concepts for specifying object schemas. Some kinds of integrity constraints, e.g. referential integrity constraints or cardinality constraints ...
متن کاملA Semantic Approach to Schema Mapping
We take schema mapping to be the problem of finding an appropriate semantic relationship to load data from a source to a target database, given their schemas. This relationship is expressed in terms of declarative logical expressions. The problem is inherently difficult to automate and previous solutions have proposed algorithms which take as input simple element correspondences between schemas...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2016